DTS Insertion Modes
You can set the insertion mode in the step Maintain technical settings. The insertion mode impacts the generated program. If you change this parameter after the program has been generated, you must repeat the program generation step for the insertion tasks again.
DTS supports the insert modes below. For more information, see the ABAP SQL help on the INSERT statement:
-
Mass modify: Calls the MODIFY SQL statement for the whole DTS package.
-
Single insert: Calls the INSERT SQL statement for each record in the DTS package record by record, e.g. if the DTS package has 1,000 records, this mode will execute 1,000 INSERT SQL statements for mass insertion into the database. This calls the INSERT SQL statement for the whole DTS package.
-
Mass insert accepting duplicate keys: Calls the INSERT SQL statement for the whole DTS package. If the insert fails due to existing records, the DTS package is inserted record by record.
-
Single insert with aggregation: Same as the single insert. However, if the operation fails on an already existing record, the record is updated based on the defined aggregation logic.
-
Mass update: Calls the UPDATE SQL statement for the whole DTS package. This mode makes sense for tables with a generated view. See the chapter Generate Views for Update.
-
Priority mass insert: Splits the records in the DTS package into records with priority and records without priority. The priority records are processed with mass modify and non-priority records are processed with mass insert accepting duplicate keys.
Automatic insert mode behaves as described based on the table settings:
Scenario | Key or unique index change | Non-key change | Different target table | Priority | Delta load | No primary key | Aggregation rule/function assigned | Chosen insert mode |
---|---|---|---|---|---|---|---|---|
Migration | X | X | Mass insert | |||||
Migration | X | Mass modify | ||||||
Migration/Conversion | X | X | Priority mass insert | |||||
Migration/Conversion | X | X | Single insert with aggregation | |||||
Conversion | X | Mass update | ||||||
Conversion | X | X | Mass modify |
If none of the setting combinations matches your table, the following insert modes will be used:
-
Migration scenario: Mass insert
-
Conversion scenario: Mass insert accepting duplicate keys